package com.cnswhy.cloud.server.core.dao;

import com.cnswhy.cloud.common.core.base.mapper.SuperMapper;
import com.cnswhy.cloud.server.common.entity.enumeration.TransType;
import com.cnswhy.cloud.server.core.entity.SpellInfo;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * <p>
 * Mapper 接口
 * 
 * </p>
 *
 * @author cnswhy
 * @date 2020-10-21
 */
@Repository
public interface SpellInfoMapper extends SuperMapper<SpellInfo> {
    @Select("select ifnull(sum(t.split_value),0) from t_spell_info t where t.sett_date = #{settDate}")
    Long getSplitValueBySettDate(@Param("settDate") String settDate);
    @Select("select ifnull(sum(t.small_value),0) from t_spell_info t where t.sett_date = #{settDate}")
    Long getSmallValueBySettDate(@Param("settDate") String settDate);
    @Select("select ifnull(sum(t.center_split_value),0) from t_spell_info t where t.sett_date = #{settDate}")
    Long getCenterSplitValueBySettDate(@Param("settDate") String settDate);
    @Select("select ifnull(sum(t.center_small_value),0) from t_spell_info t where t.sett_date = #{settDate}")
    Long getCenterSmallValueBySettDate(@Param("settDate") String settDate);

}
